-
Re: Master and metrix sheets
Ok. It looks like you are primarily going to want to use COUNTIFS functions. Here is some documentation on cross-sheet references that may come in handy: Most of your formulas are probably going to e…6 · -
Re: What is the best way to learn SmartSheet?
@L@123 "Hierarchies being inside of a program means someone has to touch every row to put them in the correct hierarchy" Yes, but one of the advantages with how my team generally uses SS is…11 · -
Formulas for Calculating Time
I have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but la…30 · -
Re: Multiple level conditions - If and/or statements
Try something like this... =IF([Meeting w Broker]@row = "Yes", IF([Meeting w Client]@row = "Yes", .8, .4), IF([Meeting w Client]@row = "Yes", .6, .15))11 · -
Re: "=IF" statement not generating correct response all of the time
Happy to help! 👍️ Don't hesitate to visit/reach out to the Community. There is a lot of knowledge floating around here, and even if you figure the answer out, you can always Comment on your own quest…5 ·